﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SalesVMTDataSet" targetNamespace="http://tempuri.org/SalesVMTDataSet.xsd" xmlns:mstns="http://tempuri.org/SalesVMTDataSet.xsd" xmlns="http://tempuri.org/SalesVMTDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SalesVMTConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="SalesVMTConnectionString (Settings)" PropertyReference="ApplicationSettings.SalesVMT.Properties.Settings.GlobalReference.Default.SalesVMTConnectionString" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CompanyTableAdapter" GeneratorDataComponentClassName="CompanyTableAdapter" Name="Company" UserDataComponentName="CompanyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Company" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Company` WHERE ((`Company_ID` = ?) AND ((? = 1 AND `Company_Code` IS NULL) OR (`Company_Code` = ?)) AND ((? = 1 AND `Company_Name` IS NULL) OR (`Company_Name` = ?)) AND ((? = 1 AND `Company_Address` IS NULL) OR (`Company_Address` = ?)) AND ((? = 1 AND `Company_Tel` IS NULL) OR (`Company_Tel` = ?)) AND ((? = 1 AND `Company_Fax` IS NULL) OR (`Company_Fax` = ?)) AND ((? = 1 AND `Company_Email` IS NULL) OR (`Company_Email` = ?)) AND ((? = 1 AND `Company_Website` IS NULL) OR (`Company_Website` = ?)) AND ((? = 1 AND `Company_Currency` IS NULL) OR (`Company_Currency` = ?)) AND ((? = 1 AND `Company_City` IS NULL) OR (`Company_City` = ?)) AND ((? = 1 AND `Company_PriceDifference` IS NULL) OR (`Company_PriceDifference` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Company_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Tel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Tel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Website" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Website" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Currency" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Currency" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_PriceDifference" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Company_PriceDifference" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Company` (`Company_ID`, `Company_Code`, `Company_Name`, `Company_Address`, `Company_Tel`, `Company_Fax`, `Company_Email`, `Company_Website`, `Company_Currency`, `Company_City`, `Company_PriceDifference`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Company_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Tel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Website" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Currency" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Company_PriceDifference" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Company_ID, Company_Code, Company_Name, Company_Address, Company_Tel, Company_Fax, Company_Email, Company_Website, Company_Currency, Company_City, Company_PriceDifference FROM Company</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Company` SET `Company_ID` = ?, `Company_Code` = ?, `Company_Name` = ?, `Company_Address` = ?, `Company_Tel` = ?, `Company_Fax` = ?, `Company_Email` = ?, `Company_Website` = ?, `Company_Currency` = ?, `Company_City` = ?, `Company_PriceDifference` = ? WHERE ((`Company_ID` = ?) AND ((? = 1 AND `Company_Code` IS NULL) OR (`Company_Code` = ?)) AND ((? = 1 AND `Company_Name` IS NULL) OR (`Company_Name` = ?)) AND ((? = 1 AND `Company_Address` IS NULL) OR (`Company_Address` = ?)) AND ((? = 1 AND `Company_Tel` IS NULL) OR (`Company_Tel` = ?)) AND ((? = 1 AND `Company_Fax` IS NULL) OR (`Company_Fax` = ?)) AND ((? = 1 AND `Company_Email` IS NULL) OR (`Company_Email` = ?)) AND ((? = 1 AND `Company_Website` IS NULL) OR (`Company_Website` = ?)) AND ((? = 1 AND `Company_Currency` IS NULL) OR (`Company_Currency` = ?)) AND ((? = 1 AND `Company_City` IS NULL) OR (`Company_City` = ?)) AND ((? = 1 AND `Company_PriceDifference` IS NULL) OR (`Company_PriceDifference` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Company_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Tel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Website" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_Currency" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Company_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Company_PriceDifference" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Company_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Tel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Tel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Tel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Email" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Website" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Website" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Website" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_Currency" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_Currency" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_Currency" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Company_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Company_City" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Company_PriceDifference" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Company_PriceDifference" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Company_PriceDifference" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Company_ID" DataSetColumn="Company_ID" />
              <Mapping SourceColumn="Company_Code" DataSetColumn="Company_Code" />
              <Mapping SourceColumn="Company_Name" DataSetColumn="Company_Name" />
              <Mapping SourceColumn="Company_Address" DataSetColumn="Company_Address" />
              <Mapping SourceColumn="Company_Tel" DataSetColumn="Company_Tel" />
              <Mapping SourceColumn="Company_Fax" DataSetColumn="Company_Fax" />
              <Mapping SourceColumn="Company_Email" DataSetColumn="Company_Email" />
              <Mapping SourceColumn="Company_Website" DataSetColumn="Company_Website" />
              <Mapping SourceColumn="Company_Currency" DataSetColumn="Company_Currency" />
              <Mapping SourceColumn="Company_City" DataSetColumn="Company_City" />
              <Mapping SourceColumn="Company_PriceDifference" DataSetColumn="Company_PriceDifference" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Customer` WHERE ((`Customer_ID` = ?) AND ((? = 1 AND `Customer_CustomerTypeID` IS NULL) OR (`Customer_CustomerTypeID` = ?)) AND ((? = 1 AND `Customer_Code` IS NULL) OR (`Customer_Code` = ?)) AND ((? = 1 AND `Customer_Name` IS NULL) OR (`Customer_Name` = ?)) AND ((? = 1 AND `Customer_Address` IS NULL) OR (`Customer_Address` = ?)) AND ((? = 1 AND `Customer_Phone` IS NULL) OR (`Customer_Phone` = ?)) AND ((? = 1 AND `Customer_Fax` IS NULL) OR (`Customer_Fax` = ?)) AND ((? = 1 AND `Customer_TaxNo` IS NULL) OR (`Customer_TaxNo` = ?)) AND ((? = 1 AND `Customer_Contact` IS NULL) OR (`Customer_Contact` = ?)) AND ((? = 1 AND `Customer_CreateDate` IS NULL) OR (`Customer_CreateDate` = ?)) AND ((? = 1 AND `Customer_Remaining` IS NULL) OR (`Customer_Remaining` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Customer_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_TaxNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Contact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Customer_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Customer_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Customer` (`Customer_CustomerTypeID`, `Customer_Code`, `Customer_Name`, `Customer_Address`, `Customer_Phone`, `Customer_Fax`, `Customer_TaxNo`, `Customer_Contact`, `Customer_CreateDate`, `Customer_Remaining`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Customer_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Customer_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Customer_ID, Customer_CustomerTypeID, Customer_Code, Customer_Name, Customer_Address, Customer_Phone, Customer_Fax, Customer_TaxNo, Customer_Contact, Customer_CreateDate, Customer_Remaining FROM Customer</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Customer` SET `Customer_CustomerTypeID` = ?, `Customer_Code` = ?, `Customer_Name` = ?, `Customer_Address` = ?, `Customer_Phone` = ?, `Customer_Fax` = ?, `Customer_TaxNo` = ?, `Customer_Contact` = ?, `Customer_CreateDate` = ?, `Customer_Remaining` = ? WHERE ((`Customer_ID` = ?) AND ((? = 1 AND `Customer_CustomerTypeID` IS NULL) OR (`Customer_CustomerTypeID` = ?)) AND ((? = 1 AND `Customer_Code` IS NULL) OR (`Customer_Code` = ?)) AND ((? = 1 AND `Customer_Name` IS NULL) OR (`Customer_Name` = ?)) AND ((? = 1 AND `Customer_Address` IS NULL) OR (`Customer_Address` = ?)) AND ((? = 1 AND `Customer_Phone` IS NULL) OR (`Customer_Phone` = ?)) AND ((? = 1 AND `Customer_Fax` IS NULL) OR (`Customer_Fax` = ?)) AND ((? = 1 AND `Customer_TaxNo` IS NULL) OR (`Customer_TaxNo` = ?)) AND ((? = 1 AND `Customer_Contact` IS NULL) OR (`Customer_Contact` = ?)) AND ((? = 1 AND `Customer_CreateDate` IS NULL) OR (`Customer_CreateDate` = ?)) AND ((? = 1 AND `Customer_Remaining` IS NULL) OR (`Customer_Remaining` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Customer_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Customer_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Customer_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Customer_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Customer_CustomerTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CustomerTypeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Fax" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_TaxNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_TaxNo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Contact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Customer_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Customer_Contact" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Customer_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Customer_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Customer_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Customer_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Customer_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Customer_ID" DataSetColumn="Customer_ID" />
              <Mapping SourceColumn="Customer_CustomerTypeID" DataSetColumn="Customer_CustomerTypeID" />
              <Mapping SourceColumn="Customer_Code" DataSetColumn="Customer_Code" />
              <Mapping SourceColumn="Customer_Name" DataSetColumn="Customer_Name" />
              <Mapping SourceColumn="Customer_Address" DataSetColumn="Customer_Address" />
              <Mapping SourceColumn="Customer_Phone" DataSetColumn="Customer_Phone" />
              <Mapping SourceColumn="Customer_Fax" DataSetColumn="Customer_Fax" />
              <Mapping SourceColumn="Customer_TaxNo" DataSetColumn="Customer_TaxNo" />
              <Mapping SourceColumn="Customer_Contact" DataSetColumn="Customer_Contact" />
              <Mapping SourceColumn="Customer_CreateDate" DataSetColumn="Customer_CreateDate" />
              <Mapping SourceColumn="Customer_Remaining" DataSetColumn="Customer_Remaining" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTypeTableAdapter" GeneratorDataComponentClassName="CustomerTypeTableAdapter" Name="CustomerType" UserDataComponentName="CustomerTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="CustomerType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `CustomerType` WHERE ((`CustomerType_ID` = ?) AND ((? = 1 AND `CustomerType_Name` IS NULL) OR (`CustomerType_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerType_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerType_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerType_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerType_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `CustomerType` (`CustomerType_Name`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerType_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT CustomerType_ID, CustomerType_Name FROM CustomerType</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `CustomerType` SET `CustomerType_Name` = ? WHERE ((`CustomerType_ID` = ?) AND ((? = 1 AND `CustomerType_Name` IS NULL) OR (`CustomerType_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustomerType_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CustomerType_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerType_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CustomerType_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CustomerType_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustomerType_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerType_ID" DataSetColumn="CustomerType_ID" />
              <Mapping SourceColumn="CustomerType_Name" DataSetColumn="CustomerType_Name" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IncomeTableAdapter" GeneratorDataComponentClassName="IncomeTableAdapter" Name="Income" UserDataComponentName="IncomeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Income" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Income` WHERE ((`Income_ID` = ?) AND ((? = 1 AND `Income_Code` IS NULL) OR (`Income_Code` = ?)) AND ((? = 1 AND `Income_Date` IS NULL) OR (`Income_Date` = ?)) AND ((? = 1 AND `Income_CustomerID` IS NULL) OR (`Income_CustomerID` = ?)) AND ((? = 1 AND `Income_Receive` IS NULL) OR (`Income_Receive` = ?)) AND ((? = 1 AND `Income_Reason` IS NULL) OR (`Income_Reason` = ?)) AND ((? = 1 AND `Income_Total` IS NULL) OR (`Income_Total` = ?)) AND ((? = 1 AND `Income_CreateDate` IS NULL) OR (`Income_CreateDate` = ?)) AND ((? = 1 AND `Income_UsersID` IS NULL) OR (`Income_UsersID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Income_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Receive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Receive" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Reason" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Reason" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Income_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Income_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Income` (`Income_Code`, `Income_Date`, `Income_CustomerID`, `Income_Receive`, `Income_Reason`, `Income_Total`, `Income_CreateDate`, `Income_UsersID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Income_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Receive" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Reason" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Income_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Income_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Income_ID, Income_Code, Income_Date, Income_CustomerID, Income_Receive, Income_Reason, Income_Total, Income_CreateDate, Income_UsersID FROM Income</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Income` SET `Income_Code` = ?, `Income_Date` = ?, `Income_CustomerID` = ?, `Income_Receive` = ?, `Income_Reason` = ?, `Income_Total` = ?, `Income_CreateDate` = ?, `Income_UsersID` = ? WHERE ((`Income_ID` = ?) AND ((? = 1 AND `Income_Code` IS NULL) OR (`Income_Code` = ?)) AND ((? = 1 AND `Income_Date` IS NULL) OR (`Income_Date` = ?)) AND ((? = 1 AND `Income_CustomerID` IS NULL) OR (`Income_CustomerID` = ?)) AND ((? = 1 AND `Income_Receive` IS NULL) OR (`Income_Receive` = ?)) AND ((? = 1 AND `Income_Reason` IS NULL) OR (`Income_Reason` = ?)) AND ((? = 1 AND `Income_Total` IS NULL) OR (`Income_Total` = ?)) AND ((? = 1 AND `Income_CreateDate` IS NULL) OR (`Income_CreateDate` = ?)) AND ((? = 1 AND `Income_UsersID` IS NULL) OR (`Income_UsersID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Income_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Receive" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Income_Reason" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Income_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Income_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Income_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Receive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Receive" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Receive" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Reason" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Income_Reason" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Income_Reason" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Income_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Income_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Income_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Income_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Income_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Income_UsersID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Income_ID" DataSetColumn="Income_ID" />
              <Mapping SourceColumn="Income_Code" DataSetColumn="Income_Code" />
              <Mapping SourceColumn="Income_Date" DataSetColumn="Income_Date" />
              <Mapping SourceColumn="Income_CustomerID" DataSetColumn="Income_CustomerID" />
              <Mapping SourceColumn="Income_Receive" DataSetColumn="Income_Receive" />
              <Mapping SourceColumn="Income_Reason" DataSetColumn="Income_Reason" />
              <Mapping SourceColumn="Income_Total" DataSetColumn="Income_Total" />
              <Mapping SourceColumn="Income_CreateDate" DataSetColumn="Income_CreateDate" />
              <Mapping SourceColumn="Income_UsersID" DataSetColumn="Income_UsersID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IncomeDetailsTableAdapter" GeneratorDataComponentClassName="IncomeDetailsTableAdapter" Name="IncomeDetails" UserDataComponentName="IncomeDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="IncomeDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `IncomeDetails` WHERE ((`IncomeDetails_ID` = ?) AND ((? = 1 AND `IncomeDetails_IncomeID` IS NULL) OR (`IncomeDetails_IncomeID` = ?)) AND ((? = 1 AND `IncomeDetails_ShipmentID` IS NULL) OR (`IncomeDetails_ShipmentID` = ?)) AND ((? = 1 AND `IncomeDetails_DebitDays` IS NULL) OR (`IncomeDetails_DebitDays` = ?)) AND ((? = 1 AND `IncomeDetails_Pay` IS NULL) OR (`IncomeDetails_Pay` = ?)) AND ((? = 1 AND `IncomeDetails_Instalment` IS NULL) OR (`IncomeDetails_Instalment` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_Pay" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_IncomeDetails_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_Instalment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_IncomeDetails_Instalment" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `IncomeDetails` (`IncomeDetails_IncomeID`, `IncomeDetails_ShipmentID`, `IncomeDetails_DebitDays`, `IncomeDetails_Pay`, `IncomeDetails_Instalment`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="IncomeDetails_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="IncomeDetails_Instalment" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT IncomeDetails_ID, IncomeDetails_IncomeID, IncomeDetails_ShipmentID, IncomeDetails_DebitDays, IncomeDetails_Pay, IncomeDetails_Instalment FROM IncomeDetails</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `IncomeDetails` SET `IncomeDetails_IncomeID` = ?, `IncomeDetails_ShipmentID` = ?, `IncomeDetails_DebitDays` = ?, `IncomeDetails_Pay` = ?, `IncomeDetails_Instalment` = ? WHERE ((`IncomeDetails_ID` = ?) AND ((? = 1 AND `IncomeDetails_IncomeID` IS NULL) OR (`IncomeDetails_IncomeID` = ?)) AND ((? = 1 AND `IncomeDetails_ShipmentID` IS NULL) OR (`IncomeDetails_ShipmentID` = ?)) AND ((? = 1 AND `IncomeDetails_DebitDays` IS NULL) OR (`IncomeDetails_DebitDays` = ?)) AND ((? = 1 AND `IncomeDetails_Pay` IS NULL) OR (`IncomeDetails_Pay` = ?)) AND ((? = 1 AND `IncomeDetails_Instalment` IS NULL) OR (`IncomeDetails_Instalment` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="IncomeDetails_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="IncomeDetails_Instalment" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_IncomeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_IncomeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_ShipmentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_ShipmentID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IncomeDetails_DebitDays" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_DebitDays" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_Pay" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_IncomeDetails_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Pay" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IncomeDetails_Instalment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_IncomeDetails_Instalment" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="IncomeDetails_Instalment" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IncomeDetails_ID" DataSetColumn="IncomeDetails_ID" />
              <Mapping SourceColumn="IncomeDetails_IncomeID" DataSetColumn="IncomeDetails_IncomeID" />
              <Mapping SourceColumn="IncomeDetails_ShipmentID" DataSetColumn="IncomeDetails_ShipmentID" />
              <Mapping SourceColumn="IncomeDetails_DebitDays" DataSetColumn="IncomeDetails_DebitDays" />
              <Mapping SourceColumn="IncomeDetails_Pay" DataSetColumn="IncomeDetails_Pay" />
              <Mapping SourceColumn="IncomeDetails_Instalment" DataSetColumn="IncomeDetails_Instalment" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ItemTableAdapter" GeneratorDataComponentClassName="ItemTableAdapter" Name="Item" UserDataComponentName="ItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Item" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Item` WHERE ((`Item_ID` = ?) AND ((? = 1 AND `Item_Code` IS NULL) OR (`Item_Code` = ?)) AND ((? = 1 AND `Item_Name` IS NULL) OR (`Item_Name` = ?)) AND ((? = 1 AND `Item_OriginID` IS NULL) OR (`Item_OriginID` = ?)) AND ((? = 1 AND `Item_UnitID` IS NULL) OR (`Item_UnitID` = ?)) AND ((? = 1 AND `Item_PurchasePrice` IS NULL) OR (`Item_PurchasePrice` = ?)) AND ((? = 1 AND `Item_WholesalePrice` IS NULL) OR (`Item_WholesalePrice` = ?)) AND ((? = 1 AND `Item_RetailPrice` IS NULL) OR (`Item_RetailPrice` = ?)) AND ((? = 1 AND `Item_CreateDate` IS NULL) OR (`Item_CreateDate` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Item_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Item_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_PurchasePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_PurchasePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_WholesalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_WholesalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_RetailPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_RetailPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Item_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Item` (`Item_Code`, `Item_Name`, `Item_OriginID`, `Item_UnitID`, `Item_PurchasePrice`, `Item_WholesalePrice`, `Item_RetailPrice`, `Item_CreateDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Item_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Item_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_PurchasePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_WholesalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_RetailPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Item_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Item_ID, Item_Code, Item_Name, Item_OriginID, Item_UnitID, Item_PurchasePrice, Item_WholesalePrice, Item_RetailPrice, Item_CreateDate FROM Item</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Item` SET `Item_Code` = ?, `Item_Name` = ?, `Item_OriginID` = ?, `Item_UnitID` = ?, `Item_PurchasePrice` = ?, `Item_WholesalePrice` = ?, `Item_RetailPrice` = ?, `Item_CreateDate` = ? WHERE ((`Item_ID` = ?) AND ((? = 1 AND `Item_Code` IS NULL) OR (`Item_Code` = ?)) AND ((? = 1 AND `Item_Name` IS NULL) OR (`Item_Name` = ?)) AND ((? = 1 AND `Item_OriginID` IS NULL) OR (`Item_OriginID` = ?)) AND ((? = 1 AND `Item_UnitID` IS NULL) OR (`Item_UnitID` = ?)) AND ((? = 1 AND `Item_PurchasePrice` IS NULL) OR (`Item_PurchasePrice` = ?)) AND ((? = 1 AND `Item_WholesalePrice` IS NULL) OR (`Item_WholesalePrice` = ?)) AND ((? = 1 AND `Item_RetailPrice` IS NULL) OR (`Item_RetailPrice` = ?)) AND ((? = 1 AND `Item_CreateDate` IS NULL) OR (`Item_CreateDate` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Item_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Item_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_PurchasePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_WholesalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Item_RetailPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Item_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Item_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Item_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Item_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_OriginID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_OriginID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Item_UnitID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_UnitID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_PurchasePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_PurchasePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_PurchasePrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_WholesalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_WholesalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_WholesalePrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_RetailPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Item_RetailPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Item_RetailPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Item_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Item_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Item_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Item_ID" DataSetColumn="Item_ID" />
              <Mapping SourceColumn="Item_Code" DataSetColumn="Item_Code" />
              <Mapping SourceColumn="Item_Name" DataSetColumn="Item_Name" />
              <Mapping SourceColumn="Item_OriginID" DataSetColumn="Item_OriginID" />
              <Mapping SourceColumn="Item_UnitID" DataSetColumn="Item_UnitID" />
              <Mapping SourceColumn="Item_PurchasePrice" DataSetColumn="Item_PurchasePrice" />
              <Mapping SourceColumn="Item_WholesalePrice" DataSetColumn="Item_WholesalePrice" />
              <Mapping SourceColumn="Item_RetailPrice" DataSetColumn="Item_RetailPrice" />
              <Mapping SourceColumn="Item_CreateDate" DataSetColumn="Item_CreateDate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OriginTableAdapter" GeneratorDataComponentClassName="OriginTableAdapter" Name="Origin" UserDataComponentName="OriginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Origin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Origin` WHERE ((`Origin_ID` = ?) AND ((? = 1 AND `Origin_Name` IS NULL) OR (`Origin_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Origin_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Origin_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Origin_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Origin_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Origin` (`Origin_Name`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Origin_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Origin_ID, Origin_Name FROM Origin</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Origin` SET `Origin_Name` = ? WHERE ((`Origin_ID` = ?) AND ((? = 1 AND `Origin_Name` IS NULL) OR (`Origin_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Origin_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Origin_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Origin_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Origin_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Origin_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Origin_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Origin_ID" DataSetColumn="Origin_ID" />
              <Mapping SourceColumn="Origin_Name" DataSetColumn="Origin_Name" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProviderTableAdapter" GeneratorDataComponentClassName="ProviderTableAdapter" Name="Provider" UserDataComponentName="ProviderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Provider" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Provider` WHERE ((`Provider_ID` = ?) AND ((? = 1 AND `Provider_Code` IS NULL) OR (`Provider_Code` = ?)) AND ((? = 1 AND `Provider_Name` IS NULL) OR (`Provider_Name` = ?)) AND ((? = 1 AND `Provider_Address` IS NULL) OR (`Provider_Address` = ?)) AND ((? = 1 AND `Provider_TaxNo` IS NULL) OR (`Provider_TaxNo` = ?)) AND ((? = 1 AND `Provider_Phone` IS NULL) OR (`Provider_Phone` = ?)) AND ((? = 1 AND `Provider_Contact` IS NULL) OR (`Provider_Contact` = ?)) AND ((? = 1 AND `Provider_CreateDate` IS NULL) OR (`Provider_CreateDate` = ?)) AND ((? = 1 AND `Provider_Remaining` IS NULL) OR (`Provider_Remaining` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Provider_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_TaxNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Contact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Provider_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Provider_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Provider` (`Provider_Code`, `Provider_Name`, `Provider_Address`, `Provider_TaxNo`, `Provider_Phone`, `Provider_Contact`, `Provider_CreateDate`, `Provider_Remaining`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Provider_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Provider_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Provider_ID, Provider_Code, Provider_Name, Provider_Address, Provider_TaxNo, Provider_Phone, Provider_Contact, Provider_CreateDate, Provider_Remaining FROM Provider</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Provider` SET `Provider_Code` = ?, `Provider_Name` = ?, `Provider_Address` = ?, `Provider_TaxNo` = ?, `Provider_Phone` = ?, `Provider_Contact` = ?, `Provider_CreateDate` = ?, `Provider_Remaining` = ? WHERE ((`Provider_ID` = ?) AND ((? = 1 AND `Provider_Code` IS NULL) OR (`Provider_Code` = ?)) AND ((? = 1 AND `Provider_Name` IS NULL) OR (`Provider_Name` = ?)) AND ((? = 1 AND `Provider_Address` IS NULL) OR (`Provider_Address` = ?)) AND ((? = 1 AND `Provider_TaxNo` IS NULL) OR (`Provider_TaxNo` = ?)) AND ((? = 1 AND `Provider_Phone` IS NULL) OR (`Provider_Phone` = ?)) AND ((? = 1 AND `Provider_Contact` IS NULL) OR (`Provider_Contact` = ?)) AND ((? = 1 AND `Provider_CreateDate` IS NULL) OR (`Provider_CreateDate` = ?)) AND ((? = 1 AND `Provider_Remaining` IS NULL) OR (`Provider_Remaining` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Provider_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Provider_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Provider_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Provider_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_TaxNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_TaxNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_TaxNo" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Phone" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Contact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Provider_Contact" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Provider_Contact" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Provider_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Provider_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Provider_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Provider_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Provider_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Provider_ID" DataSetColumn="Provider_ID" />
              <Mapping SourceColumn="Provider_Code" DataSetColumn="Provider_Code" />
              <Mapping SourceColumn="Provider_Name" DataSetColumn="Provider_Name" />
              <Mapping SourceColumn="Provider_Address" DataSetColumn="Provider_Address" />
              <Mapping SourceColumn="Provider_TaxNo" DataSetColumn="Provider_TaxNo" />
              <Mapping SourceColumn="Provider_Phone" DataSetColumn="Provider_Phone" />
              <Mapping SourceColumn="Provider_Contact" DataSetColumn="Provider_Contact" />
              <Mapping SourceColumn="Provider_CreateDate" DataSetColumn="Provider_CreateDate" />
              <Mapping SourceColumn="Provider_Remaining" DataSetColumn="Provider_Remaining" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReceiptTableAdapter" GeneratorDataComponentClassName="ReceiptTableAdapter" Name="Receipt" UserDataComponentName="ReceiptTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Receipt" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Receipt` WHERE ((`Receipt_ID` = ?) AND ((? = 1 AND `Receipt_Code` IS NULL) OR (`Receipt_Code` = ?)) AND ((? = 1 AND `Receipt_Date` IS NULL) OR (`Receipt_Date` = ?)) AND ((? = 1 AND `Receipt_Sender` IS NULL) OR (`Receipt_Sender` = ?)) AND ((? = 1 AND `Receipt_ProviderID` IS NULL) OR (`Receipt_ProviderID` = ?)) AND ((? = 1 AND `Receipt_TotalPrice` IS NULL) OR (`Receipt_TotalPrice` = ?)) AND ((? = 1 AND `Receipt_TotalDownPrice` IS NULL) OR (`Receipt_TotalDownPrice` = ?)) AND ((? = 1 AND `Receipt_TotalVAT` IS NULL) OR (`Receipt_TotalVAT` = ?)) AND ((? = 1 AND `Receipt_Total` IS NULL) OR (`Receipt_Total` = ?)) AND ((? = 1 AND `Receipt_Remaining` IS NULL) OR (`Receipt_Remaining` = ?)) AND ((? = 1 AND `Receipt_Pay` IS NULL) OR (`Receipt_Pay` = ?)) AND ((? = 1 AND `Receipt_CreateDate` IS NULL) OR (`Receipt_CreateDate` = ?)) AND ((? = 1 AND `Receipt_UsersID` IS NULL) OR (`Receipt_UsersID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Receipt_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Receipt_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Sender" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Receipt_Sender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalDownPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalDownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalVAT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalVAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Pay" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Receipt_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Receipt` (`Receipt_Code`, `Receipt_Date`, `Receipt_Sender`, `Receipt_ProviderID`, `Receipt_TotalPrice`, `Receipt_TotalDownPrice`, `Receipt_TotalVAT`, `Receipt_Total`, `Receipt_Remaining`, `Receipt_Pay`, `Receipt_CreateDate`, `Receipt_UsersID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Receipt_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Receipt_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Receipt_Sender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalDownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalVAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Receipt_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Receipt_ID, Receipt_Code, Receipt_Date, Receipt_Sender, Receipt_ProviderID, Receipt_TotalPrice, Receipt_TotalDownPrice, Receipt_TotalVAT, Receipt_Total, Receipt_Remaining, Receipt_Pay, Receipt_CreateDate, Receipt_UsersID FROM Receipt</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Receipt` SET `Receipt_Code` = ?, `Receipt_Date` = ?, `Receipt_Sender` = ?, `Receipt_ProviderID` = ?, `Receipt_TotalPrice` = ?, `Receipt_TotalDownPrice` = ?, `Receipt_TotalVAT` = ?, `Receipt_Total` = ?, `Receipt_Remaining` = ?, `Receipt_Pay` = ?, `Receipt_CreateDate` = ?, `Receipt_UsersID` = ? WHERE ((`Receipt_ID` = ?) AND ((? = 1 AND `Receipt_Code` IS NULL) OR (`Receipt_Code` = ?)) AND ((? = 1 AND `Receipt_Date` IS NULL) OR (`Receipt_Date` = ?)) AND ((? = 1 AND `Receipt_Sender` IS NULL) OR (`Receipt_Sender` = ?)) AND ((? = 1 AND `Receipt_ProviderID` IS NULL) OR (`Receipt_ProviderID` = ?)) AND ((? = 1 AND `Receipt_TotalPrice` IS NULL) OR (`Receipt_TotalPrice` = ?)) AND ((? = 1 AND `Receipt_TotalDownPrice` IS NULL) OR (`Receipt_TotalDownPrice` = ?)) AND ((? = 1 AND `Receipt_TotalVAT` IS NULL) OR (`Receipt_TotalVAT` = ?)) AND ((? = 1 AND `Receipt_Total` IS NULL) OR (`Receipt_Total` = ?)) AND ((? = 1 AND `Receipt_Remaining` IS NULL) OR (`Receipt_Remaining` = ?)) AND ((? = 1 AND `Receipt_Pay` IS NULL) OR (`Receipt_Pay` = ?)) AND ((? = 1 AND `Receipt_CreateDate` IS NULL) OR (`Receipt_CreateDate` = ?)) AND ((? = 1 AND `Receipt_UsersID` IS NULL) OR (`Receipt_UsersID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Receipt_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Receipt_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Receipt_Sender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalDownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_TotalVAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Receipt_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Receipt_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Code" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Receipt_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Date" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Receipt_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_Date" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Sender" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Receipt_Sender" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Receipt_Sender" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_ProviderID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_ProviderID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalDownPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalDownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalDownPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_TotalVAT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_TotalVAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_TotalVAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Remaining" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Remaining" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Remaining" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_Pay" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Receipt_Pay" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Receipt_Pay" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_CreateDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Receipt_CreateDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Receipt_CreateDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Receipt_UsersID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Receipt_UsersID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Receipt_ID" DataSetColumn="Receipt_ID" />
              <Mapping SourceColumn="Receipt_Code" DataSetColumn="Receipt_Code" />
              <Mapping SourceColumn="Receipt_Date" DataSetColumn="Receipt_Date" />
              <Mapping SourceColumn="Receipt_Sender" DataSetColumn="Receipt_Sender" />
              <Mapping SourceColumn="Receipt_ProviderID" DataSetColumn="Receipt_ProviderID" />
              <Mapping SourceColumn="Receipt_TotalPrice" DataSetColumn="Receipt_TotalPrice" />
              <Mapping SourceColumn="Receipt_TotalDownPrice" DataSetColumn="Receipt_TotalDownPrice" />
              <Mapping SourceColumn="Receipt_TotalVAT" DataSetColumn="Receipt_TotalVAT" />
              <Mapping SourceColumn="Receipt_Total" DataSetColumn="Receipt_Total" />
              <Mapping SourceColumn="Receipt_Remaining" DataSetColumn="Receipt_Remaining" />
              <Mapping SourceColumn="Receipt_Pay" DataSetColumn="Receipt_Pay" />
              <Mapping SourceColumn="Receipt_CreateDate" DataSetColumn="Receipt_CreateDate" />
              <Mapping SourceColumn="Receipt_UsersID" DataSetColumn="Receipt_UsersID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReceiptDetailsTableAdapter" GeneratorDataComponentClassName="ReceiptDetailsTableAdapter" Name="ReceiptDetails" UserDataComponentName="ReceiptDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="ReceiptDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `ReceiptDetails` WHERE ((`ReceiptDetails_ID` = ?) AND ((? = 1 AND `ReceiptDetails_ReceiptID` IS NULL) OR (`ReceiptDetails_ReceiptID` = ?)) AND ((? = 1 AND `ReceiptDetails_ItemID` IS NULL) OR (`ReceiptDetails_ItemID` = ?)) AND ((? = 1 AND `ReceiptDetails_Quantity` IS NULL) OR (`ReceiptDetails_Quantity` = ?)) AND ((? = 1 AND `ReceiptDetails_Price` IS NULL) OR (`ReceiptDetails_Price` = ?)) AND ((? = 1 AND `ReceiptDetails_DownPrice` IS NULL) OR (`ReceiptDetails_DownPrice` = ?)) AND ((? = 1 AND `ReceiptDetails_VAT` IS NULL) OR (`ReceiptDetails_VAT` = ?)) AND ((? = 1 AND `ReceiptDetails_Total` IS NULL) OR (`ReceiptDetails_Total` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_DownPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_DownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_VAT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_VAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `ReceiptDetails` (`ReceiptDetails_ReceiptID`, `ReceiptDetails_ItemID`, `ReceiptDetails_Quantity`, `ReceiptDetails_Price`, `ReceiptDetails_DownPrice`, `ReceiptDetails_VAT`, `ReceiptDetails_Total`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_DownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_VAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ReceiptDetails_ID, ReceiptDetails_ReceiptID, ReceiptDetails_ItemID, ReceiptDetails_Quantity, ReceiptDetails_Price, ReceiptDetails_DownPrice, ReceiptDetails_VAT, ReceiptDetails_Total FROM ReceiptDetails</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `ReceiptDetails` SET `ReceiptDetails_ReceiptID` = ?, `ReceiptDetails_ItemID` = ?, `ReceiptDetails_Quantity` = ?, `ReceiptDetails_Price` = ?, `ReceiptDetails_DownPrice` = ?, `ReceiptDetails_VAT` = ?, `ReceiptDetails_Total` = ? WHERE ((`ReceiptDetails_ID` = ?) AND ((? = 1 AND `ReceiptDetails_ReceiptID` IS NULL) OR (`ReceiptDetails_ReceiptID` = ?)) AND ((? = 1 AND `ReceiptDetails_ItemID` IS NULL) OR (`ReceiptDetails_ItemID` = ?)) AND ((? = 1 AND `ReceiptDetails_Quantity` IS NULL) OR (`ReceiptDetails_Quantity` = ?)) AND ((? = 1 AND `ReceiptDetails_Price` IS NULL) OR (`ReceiptDetails_Price` = ?)) AND ((? = 1 AND `ReceiptDetails_DownPrice` IS NULL) OR (`ReceiptDetails_DownPrice` = ?)) AND ((? = 1 AND `ReceiptDetails_VAT` IS NULL) OR (`ReceiptDetails_VAT` = ?)) AND ((? = 1 AND `ReceiptDetails_Total` IS NULL) OR (`ReceiptDetails_Total` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_DownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_VAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="ReceiptDetails_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ReceiptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ReceiptID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_ItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_ItemID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReceiptDetails_Quantity" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Quantity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Price" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_DownPrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_DownPrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_DownPrice" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_VAT" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_VAT" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReceiptDetails_Total" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_ReceiptDetails_Total" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="ReceiptDetails_Total" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReceiptDetails_ID" DataSetColumn="ReceiptDetails_ID" />
              <Mapping SourceColumn="ReceiptDetails_ReceiptID" DataSetColumn="ReceiptDetails_ReceiptID" />
              <Mapping SourceColumn="ReceiptDetails_ItemID" DataSetColumn="ReceiptDetails_ItemID" />
              <Mapping SourceColumn="ReceiptDetails_Quantity" DataSetColumn="ReceiptDetails_Quantity" />
              <Mapping SourceColumn="ReceiptDetails_Price" DataSetColumn="ReceiptDetails_Price" />
              <Mapping SourceColumn="ReceiptDetails_DownPrice" DataSetColumn="ReceiptDetails_DownPrice" />
              <Mapping SourceColumn="ReceiptDetails_VAT" DataSetColumn="ReceiptDetails_VAT" />
              <Mapping SourceColumn="ReceiptDetails_Total" DataSetColumn="ReceiptDetails_Total" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnitTableAdapter" GeneratorDataComponentClassName="UnitTableAdapter" Name="Unit" UserDataComponentName="UnitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SalesVMTConnectionString (Settings)" DbObjectName="Unit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Unit` WHERE ((`Unit_ID` = ?) AND ((? = 1 AND `Unit_Name` IS NULL) OR (`Unit_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Unit_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Unit_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Unit_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Unit` (`Unit_Name`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Unit_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Unit_ID, Unit_Name FROM Unit</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Unit` SET `Unit_Name` = ? WHERE ((`Unit_ID` = ?) AND ((? = 1 AND `Unit_Name` IS NULL) OR (`Unit_Name` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Unit_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Unit_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Unit_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Unit_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Unit_Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Unit_ID" DataSetColumn="Unit_ID" />
              <Mapping SourceColumn="Unit_Name" DataSetColumn="Unit_Name" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SalesVMTDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SalesVMTDataSet" msprop:Generator_DataSetName="SalesVMTDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Company" msprop:Generator_UserTableName="Company" msprop:Generator_RowDeletedName="CompanyRowDeleted" msprop:Generator_TableClassName="CompanyDataTable" msprop:Generator_RowChangedName="CompanyRowChanged" msprop:Generator_RowClassName="CompanyRow" msprop:Generator_RowChangingName="CompanyRowChanging" msprop:Generator_RowEvArgName="CompanyRowChangeEvent" msprop:Generator_RowEvHandlerName="CompanyRowChangeEventHandler" msprop:Generator_TablePropName="Company" msprop:Generator_TableVarName="tableCompany" msprop:Generator_RowDeletingName="CompanyRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Company_ID" msprop:Generator_UserColumnName="Company_ID" msprop:Generator_ColumnPropNameInRow="Company_ID" msprop:Generator_ColumnVarNameInTable="columnCompany_ID" msprop:Generator_ColumnPropNameInTable="Company_IDColumn" type="xs:int" />
              <xs:element name="Company_Code" msprop:Generator_UserColumnName="Company_Code" msprop:Generator_ColumnPropNameInRow="Company_Code" msprop:Generator_ColumnVarNameInTable="columnCompany_Code" msprop:Generator_ColumnPropNameInTable="Company_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Name" msprop:Generator_UserColumnName="Company_Name" msprop:Generator_ColumnPropNameInRow="Company_Name" msprop:Generator_ColumnVarNameInTable="columnCompany_Name" msprop:Generator_ColumnPropNameInTable="Company_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Address" msprop:Generator_UserColumnName="Company_Address" msprop:Generator_ColumnPropNameInRow="Company_Address" msprop:Generator_ColumnVarNameInTable="columnCompany_Address" msprop:Generator_ColumnPropNameInTable="Company_AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Tel" msprop:Generator_UserColumnName="Company_Tel" msprop:Generator_ColumnPropNameInRow="Company_Tel" msprop:Generator_ColumnVarNameInTable="columnCompany_Tel" msprop:Generator_ColumnPropNameInTable="Company_TelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Fax" msprop:Generator_UserColumnName="Company_Fax" msprop:Generator_ColumnPropNameInRow="Company_Fax" msprop:Generator_ColumnVarNameInTable="columnCompany_Fax" msprop:Generator_ColumnPropNameInTable="Company_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Email" msprop:Generator_UserColumnName="Company_Email" msprop:Generator_ColumnPropNameInRow="Company_Email" msprop:Generator_ColumnVarNameInTable="columnCompany_Email" msprop:Generator_ColumnPropNameInTable="Company_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Website" msprop:Generator_UserColumnName="Company_Website" msprop:Generator_ColumnPropNameInRow="Company_Website" msprop:Generator_ColumnVarNameInTable="columnCompany_Website" msprop:Generator_ColumnPropNameInTable="Company_WebsiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Currency" msprop:Generator_UserColumnName="Company_Currency" msprop:Generator_ColumnPropNameInRow="Company_Currency" msprop:Generator_ColumnVarNameInTable="columnCompany_Currency" msprop:Generator_ColumnPropNameInTable="Company_CurrencyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_City" msprop:Generator_UserColumnName="Company_City" msprop:Generator_ColumnPropNameInRow="Company_City" msprop:Generator_ColumnVarNameInTable="columnCompany_City" msprop:Generator_ColumnPropNameInTable="Company_CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_PriceDifference" msprop:Generator_UserColumnName="Company_PriceDifference" msprop:Generator_ColumnPropNameInRow="Company_PriceDifference" msprop:Generator_ColumnVarNameInTable="columnCompany_PriceDifference" msprop:Generator_ColumnPropNameInTable="Company_PriceDifferenceColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer" msprop:Generator_UserTableName="Customer" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_TablePropName="Customer" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowDeletingName="CustomerRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Customer_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Customer_ID" msprop:Generator_ColumnPropNameInRow="Customer_ID" msprop:Generator_ColumnVarNameInTable="columnCustomer_ID" msprop:Generator_ColumnPropNameInTable="Customer_IDColumn" type="xs:int" />
              <xs:element name="Customer_CustomerTypeID" msprop:Generator_UserColumnName="Customer_CustomerTypeID" msprop:Generator_ColumnPropNameInRow="Customer_CustomerTypeID" msprop:Generator_ColumnVarNameInTable="columnCustomer_CustomerTypeID" msprop:Generator_ColumnPropNameInTable="Customer_CustomerTypeIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Customer_Code" msprop:Generator_UserColumnName="Customer_Code" msprop:Generator_ColumnPropNameInRow="Customer_Code" msprop:Generator_ColumnVarNameInTable="columnCustomer_Code" msprop:Generator_ColumnPropNameInTable="Customer_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_Name" msprop:Generator_UserColumnName="Customer_Name" msprop:Generator_ColumnPropNameInRow="Customer_Name" msprop:Generator_ColumnVarNameInTable="columnCustomer_Name" msprop:Generator_ColumnPropNameInTable="Customer_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_Address" msprop:Generator_UserColumnName="Customer_Address" msprop:Generator_ColumnPropNameInRow="Customer_Address" msprop:Generator_ColumnVarNameInTable="columnCustomer_Address" msprop:Generator_ColumnPropNameInTable="Customer_AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_Phone" msprop:Generator_UserColumnName="Customer_Phone" msprop:Generator_ColumnPropNameInRow="Customer_Phone" msprop:Generator_ColumnVarNameInTable="columnCustomer_Phone" msprop:Generator_ColumnPropNameInTable="Customer_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_Fax" msprop:Generator_UserColumnName="Customer_Fax" msprop:Generator_ColumnPropNameInRow="Customer_Fax" msprop:Generator_ColumnVarNameInTable="columnCustomer_Fax" msprop:Generator_ColumnPropNameInTable="Customer_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_TaxNo" msprop:Generator_UserColumnName="Customer_TaxNo" msprop:Generator_ColumnPropNameInRow="Customer_TaxNo" msprop:Generator_ColumnVarNameInTable="columnCustomer_TaxNo" msprop:Generator_ColumnPropNameInTable="Customer_TaxNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_Contact" msprop:Generator_UserColumnName="Customer_Contact" msprop:Generator_ColumnPropNameInRow="Customer_Contact" msprop:Generator_ColumnVarNameInTable="columnCustomer_Contact" msprop:Generator_ColumnPropNameInTable="Customer_ContactColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Customer_CreateDate" msprop:Generator_UserColumnName="Customer_CreateDate" msprop:Generator_ColumnPropNameInRow="Customer_CreateDate" msprop:Generator_ColumnVarNameInTable="columnCustomer_CreateDate" msprop:Generator_ColumnPropNameInTable="Customer_CreateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Customer_Remaining" msprop:Generator_UserColumnName="Customer_Remaining" msprop:Generator_ColumnPropNameInRow="Customer_Remaining" msprop:Generator_ColumnVarNameInTable="columnCustomer_Remaining" msprop:Generator_ColumnPropNameInTable="Customer_RemainingColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CustomerType" msprop:Generator_UserTableName="CustomerType" msprop:Generator_RowDeletedName="CustomerTypeRowDeleted" msprop:Generator_TableClassName="CustomerTypeDataTable" msprop:Generator_RowChangedName="CustomerTypeRowChanged" msprop:Generator_RowClassName="CustomerTypeRow" msprop:Generator_RowChangingName="CustomerTypeRowChanging" msprop:Generator_RowEvArgName="CustomerTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerTypeRowChangeEventHandler" msprop:Generator_TablePropName="CustomerType" msprop:Generator_TableVarName="tableCustomerType" msprop:Generator_RowDeletingName="CustomerTypeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerType_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CustomerType_ID" msprop:Generator_ColumnPropNameInRow="CustomerType_ID" msprop:Generator_ColumnVarNameInTable="columnCustomerType_ID" msprop:Generator_ColumnPropNameInTable="CustomerType_IDColumn" type="xs:int" />
              <xs:element name="CustomerType_Name" msprop:Generator_UserColumnName="CustomerType_Name" msprop:Generator_ColumnPropNameInRow="CustomerType_Name" msprop:Generator_ColumnVarNameInTable="columnCustomerType_Name" msprop:Generator_ColumnPropNameInTable="CustomerType_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Income" msprop:Generator_UserTableName="Income" msprop:Generator_RowDeletedName="IncomeRowDeleted" msprop:Generator_TableClassName="IncomeDataTable" msprop:Generator_RowChangedName="IncomeRowChanged" msprop:Generator_RowClassName="IncomeRow" msprop:Generator_RowChangingName="IncomeRowChanging" msprop:Generator_RowEvArgName="IncomeRowChangeEvent" msprop:Generator_RowEvHandlerName="IncomeRowChangeEventHandler" msprop:Generator_TablePropName="Income" msprop:Generator_TableVarName="tableIncome" msprop:Generator_RowDeletingName="IncomeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Income_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Income_ID" msprop:Generator_ColumnPropNameInRow="Income_ID" msprop:Generator_ColumnVarNameInTable="columnIncome_ID" msprop:Generator_ColumnPropNameInTable="Income_IDColumn" type="xs:int" />
              <xs:element name="Income_Code" msprop:Generator_UserColumnName="Income_Code" msprop:Generator_ColumnPropNameInRow="Income_Code" msprop:Generator_ColumnVarNameInTable="columnIncome_Code" msprop:Generator_ColumnPropNameInTable="Income_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Income_Date" msprop:Generator_UserColumnName="Income_Date" msprop:Generator_ColumnPropNameInRow="Income_Date" msprop:Generator_ColumnVarNameInTable="columnIncome_Date" msprop:Generator_ColumnPropNameInTable="Income_DateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Income_CustomerID" msprop:Generator_UserColumnName="Income_CustomerID" msprop:Generator_ColumnPropNameInRow="Income_CustomerID" msprop:Generator_ColumnVarNameInTable="columnIncome_CustomerID" msprop:Generator_ColumnPropNameInTable="Income_CustomerIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Income_Receive" msprop:Generator_UserColumnName="Income_Receive" msprop:Generator_ColumnPropNameInRow="Income_Receive" msprop:Generator_ColumnVarNameInTable="columnIncome_Receive" msprop:Generator_ColumnPropNameInTable="Income_ReceiveColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Income_Reason" msprop:Generator_UserColumnName="Income_Reason" msprop:Generator_ColumnPropNameInRow="Income_Reason" msprop:Generator_ColumnVarNameInTable="columnIncome_Reason" msprop:Generator_ColumnPropNameInTable="Income_ReasonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Income_Total" msprop:Generator_UserColumnName="Income_Total" msprop:Generator_ColumnPropNameInRow="Income_Total" msprop:Generator_ColumnVarNameInTable="columnIncome_Total" msprop:Generator_ColumnPropNameInTable="Income_TotalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Income_CreateDate" msprop:Generator_UserColumnName="Income_CreateDate" msprop:Generator_ColumnPropNameInRow="Income_CreateDate" msprop:Generator_ColumnVarNameInTable="columnIncome_CreateDate" msprop:Generator_ColumnPropNameInTable="Income_CreateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Income_UsersID" msprop:Generator_UserColumnName="Income_UsersID" msprop:Generator_ColumnPropNameInRow="Income_UsersID" msprop:Generator_ColumnVarNameInTable="columnIncome_UsersID" msprop:Generator_ColumnPropNameInTable="Income_UsersIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IncomeDetails" msprop:Generator_UserTableName="IncomeDetails" msprop:Generator_RowDeletedName="IncomeDetailsRowDeleted" msprop:Generator_TableClassName="IncomeDetailsDataTable" msprop:Generator_RowChangedName="IncomeDetailsRowChanged" msprop:Generator_RowClassName="IncomeDetailsRow" msprop:Generator_RowChangingName="IncomeDetailsRowChanging" msprop:Generator_RowEvArgName="IncomeDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="IncomeDetailsRowChangeEventHandler" msprop:Generator_TablePropName="IncomeDetails" msprop:Generator_TableVarName="tableIncomeDetails" msprop:Generator_RowDeletingName="IncomeDetailsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IncomeDetails_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="IncomeDetails_ID" msprop:Generator_ColumnPropNameInRow="IncomeDetails_ID" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_ID" msprop:Generator_ColumnPropNameInTable="IncomeDetails_IDColumn" type="xs:int" />
              <xs:element name="IncomeDetails_IncomeID" msprop:Generator_UserColumnName="IncomeDetails_IncomeID" msprop:Generator_ColumnPropNameInRow="IncomeDetails_IncomeID" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_IncomeID" msprop:Generator_ColumnPropNameInTable="IncomeDetails_IncomeIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IncomeDetails_ShipmentID" msprop:Generator_UserColumnName="IncomeDetails_ShipmentID" msprop:Generator_ColumnPropNameInRow="IncomeDetails_ShipmentID" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_ShipmentID" msprop:Generator_ColumnPropNameInTable="IncomeDetails_ShipmentIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IncomeDetails_DebitDays" msprop:Generator_UserColumnName="IncomeDetails_DebitDays" msprop:Generator_ColumnPropNameInRow="IncomeDetails_DebitDays" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_DebitDays" msprop:Generator_ColumnPropNameInTable="IncomeDetails_DebitDaysColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IncomeDetails_Pay" msprop:Generator_UserColumnName="IncomeDetails_Pay" msprop:Generator_ColumnPropNameInRow="IncomeDetails_Pay" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_Pay" msprop:Generator_ColumnPropNameInTable="IncomeDetails_PayColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IncomeDetails_Instalment" msprop:Generator_UserColumnName="IncomeDetails_Instalment" msprop:Generator_ColumnPropNameInRow="IncomeDetails_Instalment" msprop:Generator_ColumnVarNameInTable="columnIncomeDetails_Instalment" msprop:Generator_ColumnPropNameInTable="IncomeDetails_InstalmentColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Item" msprop:Generator_UserTableName="Item" msprop:Generator_RowDeletedName="ItemRowDeleted" msprop:Generator_TableClassName="ItemDataTable" msprop:Generator_RowChangedName="ItemRowChanged" msprop:Generator_RowClassName="ItemRow" msprop:Generator_RowChangingName="ItemRowChanging" msprop:Generator_RowEvArgName="ItemRowChangeEvent" msprop:Generator_RowEvHandlerName="ItemRowChangeEventHandler" msprop:Generator_TablePropName="Item" msprop:Generator_TableVarName="tableItem" msprop:Generator_RowDeletingName="ItemRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Item_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Item_ID" msprop:Generator_ColumnPropNameInRow="Item_ID" msprop:Generator_ColumnVarNameInTable="columnItem_ID" msprop:Generator_ColumnPropNameInTable="Item_IDColumn" type="xs:int" />
              <xs:element name="Item_Code" msprop:Generator_UserColumnName="Item_Code" msprop:Generator_ColumnPropNameInRow="Item_Code" msprop:Generator_ColumnVarNameInTable="columnItem_Code" msprop:Generator_ColumnPropNameInTable="Item_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Item_Name" msprop:Generator_UserColumnName="Item_Name" msprop:Generator_ColumnPropNameInRow="Item_Name" msprop:Generator_ColumnVarNameInTable="columnItem_Name" msprop:Generator_ColumnPropNameInTable="Item_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Item_OriginID" msprop:Generator_UserColumnName="Item_OriginID" msprop:Generator_ColumnPropNameInRow="Item_OriginID" msprop:Generator_ColumnVarNameInTable="columnItem_OriginID" msprop:Generator_ColumnPropNameInTable="Item_OriginIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Item_UnitID" msprop:Generator_UserColumnName="Item_UnitID" msprop:Generator_ColumnPropNameInRow="Item_UnitID" msprop:Generator_ColumnVarNameInTable="columnItem_UnitID" msprop:Generator_ColumnPropNameInTable="Item_UnitIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Item_PurchasePrice" msprop:Generator_UserColumnName="Item_PurchasePrice" msprop:Generator_ColumnPropNameInRow="Item_PurchasePrice" msprop:Generator_ColumnVarNameInTable="columnItem_PurchasePrice" msprop:Generator_ColumnPropNameInTable="Item_PurchasePriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Item_WholesalePrice" msprop:Generator_UserColumnName="Item_WholesalePrice" msprop:Generator_ColumnPropNameInRow="Item_WholesalePrice" msprop:Generator_ColumnVarNameInTable="columnItem_WholesalePrice" msprop:Generator_ColumnPropNameInTable="Item_WholesalePriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Item_RetailPrice" msprop:Generator_UserColumnName="Item_RetailPrice" msprop:Generator_ColumnPropNameInRow="Item_RetailPrice" msprop:Generator_ColumnVarNameInTable="columnItem_RetailPrice" msprop:Generator_ColumnPropNameInTable="Item_RetailPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Item_CreateDate" msprop:Generator_UserColumnName="Item_CreateDate" msprop:Generator_ColumnPropNameInRow="Item_CreateDate" msprop:Generator_ColumnVarNameInTable="columnItem_CreateDate" msprop:Generator_ColumnPropNameInTable="Item_CreateDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Origin" msprop:Generator_UserTableName="Origin" msprop:Generator_RowDeletedName="OriginRowDeleted" msprop:Generator_TableClassName="OriginDataTable" msprop:Generator_RowChangedName="OriginRowChanged" msprop:Generator_RowClassName="OriginRow" msprop:Generator_RowChangingName="OriginRowChanging" msprop:Generator_RowEvArgName="OriginRowChangeEvent" msprop:Generator_RowEvHandlerName="OriginRowChangeEventHandler" msprop:Generator_TablePropName="Origin" msprop:Generator_TableVarName="tableOrigin" msprop:Generator_RowDeletingName="OriginRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Origin_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Origin_ID" msprop:Generator_ColumnPropNameInRow="Origin_ID" msprop:Generator_ColumnVarNameInTable="columnOrigin_ID" msprop:Generator_ColumnPropNameInTable="Origin_IDColumn" type="xs:int" />
              <xs:element name="Origin_Name" msprop:Generator_UserColumnName="Origin_Name" msprop:Generator_ColumnPropNameInRow="Origin_Name" msprop:Generator_ColumnVarNameInTable="columnOrigin_Name" msprop:Generator_ColumnPropNameInTable="Origin_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Provider" msprop:Generator_UserTableName="Provider" msprop:Generator_RowDeletedName="ProviderRowDeleted" msprop:Generator_TableClassName="ProviderDataTable" msprop:Generator_RowChangedName="ProviderRowChanged" msprop:Generator_RowClassName="ProviderRow" msprop:Generator_RowChangingName="ProviderRowChanging" msprop:Generator_RowEvArgName="ProviderRowChangeEvent" msprop:Generator_RowEvHandlerName="ProviderRowChangeEventHandler" msprop:Generator_TablePropName="Provider" msprop:Generator_TableVarName="tableProvider" msprop:Generator_RowDeletingName="ProviderRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Provider_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Provider_ID" msprop:Generator_ColumnPropNameInRow="Provider_ID" msprop:Generator_ColumnVarNameInTable="columnProvider_ID" msprop:Generator_ColumnPropNameInTable="Provider_IDColumn" type="xs:int" />
              <xs:element name="Provider_Code" msprop:Generator_UserColumnName="Provider_Code" msprop:Generator_ColumnPropNameInRow="Provider_Code" msprop:Generator_ColumnVarNameInTable="columnProvider_Code" msprop:Generator_ColumnPropNameInTable="Provider_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_Name" msprop:Generator_UserColumnName="Provider_Name" msprop:Generator_ColumnPropNameInRow="Provider_Name" msprop:Generator_ColumnVarNameInTable="columnProvider_Name" msprop:Generator_ColumnPropNameInTable="Provider_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_Address" msprop:Generator_UserColumnName="Provider_Address" msprop:Generator_ColumnPropNameInRow="Provider_Address" msprop:Generator_ColumnVarNameInTable="columnProvider_Address" msprop:Generator_ColumnPropNameInTable="Provider_AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_TaxNo" msprop:Generator_UserColumnName="Provider_TaxNo" msprop:Generator_ColumnPropNameInRow="Provider_TaxNo" msprop:Generator_ColumnVarNameInTable="columnProvider_TaxNo" msprop:Generator_ColumnPropNameInTable="Provider_TaxNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_Phone" msprop:Generator_UserColumnName="Provider_Phone" msprop:Generator_ColumnPropNameInRow="Provider_Phone" msprop:Generator_ColumnVarNameInTable="columnProvider_Phone" msprop:Generator_ColumnPropNameInTable="Provider_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_Contact" msprop:Generator_UserColumnName="Provider_Contact" msprop:Generator_ColumnPropNameInRow="Provider_Contact" msprop:Generator_ColumnVarNameInTable="columnProvider_Contact" msprop:Generator_ColumnPropNameInTable="Provider_ContactColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Provider_CreateDate" msprop:Generator_UserColumnName="Provider_CreateDate" msprop:Generator_ColumnPropNameInRow="Provider_CreateDate" msprop:Generator_ColumnVarNameInTable="columnProvider_CreateDate" msprop:Generator_ColumnPropNameInTable="Provider_CreateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Provider_Remaining" msprop:Generator_UserColumnName="Provider_Remaining" msprop:Generator_ColumnPropNameInRow="Provider_Remaining" msprop:Generator_ColumnVarNameInTable="columnProvider_Remaining" msprop:Generator_ColumnPropNameInTable="Provider_RemainingColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Receipt" msprop:Generator_UserTableName="Receipt" msprop:Generator_RowDeletedName="ReceiptRowDeleted" msprop:Generator_TableClassName="ReceiptDataTable" msprop:Generator_RowChangedName="ReceiptRowChanged" msprop:Generator_RowClassName="ReceiptRow" msprop:Generator_RowChangingName="ReceiptRowChanging" msprop:Generator_RowEvArgName="ReceiptRowChangeEvent" msprop:Generator_RowEvHandlerName="ReceiptRowChangeEventHandler" msprop:Generator_TablePropName="Receipt" msprop:Generator_TableVarName="tableReceipt" msprop:Generator_RowDeletingName="ReceiptRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Receipt_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Receipt_ID" msprop:Generator_ColumnPropNameInRow="Receipt_ID" msprop:Generator_ColumnVarNameInTable="columnReceipt_ID" msprop:Generator_ColumnPropNameInTable="Receipt_IDColumn" type="xs:int" />
              <xs:element name="Receipt_Code" msprop:Generator_UserColumnName="Receipt_Code" msprop:Generator_ColumnPropNameInRow="Receipt_Code" msprop:Generator_ColumnVarNameInTable="columnReceipt_Code" msprop:Generator_ColumnPropNameInTable="Receipt_CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Receipt_Date" msprop:Generator_UserColumnName="Receipt_Date" msprop:Generator_ColumnPropNameInRow="Receipt_Date" msprop:Generator_ColumnVarNameInTable="columnReceipt_Date" msprop:Generator_ColumnPropNameInTable="Receipt_DateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Receipt_Sender" msprop:Generator_UserColumnName="Receipt_Sender" msprop:Generator_ColumnPropNameInRow="Receipt_Sender" msprop:Generator_ColumnVarNameInTable="columnReceipt_Sender" msprop:Generator_ColumnPropNameInTable="Receipt_SenderColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Receipt_ProviderID" msprop:Generator_UserColumnName="Receipt_ProviderID" msprop:Generator_ColumnPropNameInRow="Receipt_ProviderID" msprop:Generator_ColumnVarNameInTable="columnReceipt_ProviderID" msprop:Generator_ColumnPropNameInTable="Receipt_ProviderIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Receipt_TotalPrice" msprop:Generator_UserColumnName="Receipt_TotalPrice" msprop:Generator_ColumnPropNameInRow="Receipt_TotalPrice" msprop:Generator_ColumnVarNameInTable="columnReceipt_TotalPrice" msprop:Generator_ColumnPropNameInTable="Receipt_TotalPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_TotalDownPrice" msprop:Generator_UserColumnName="Receipt_TotalDownPrice" msprop:Generator_ColumnPropNameInRow="Receipt_TotalDownPrice" msprop:Generator_ColumnVarNameInTable="columnReceipt_TotalDownPrice" msprop:Generator_ColumnPropNameInTable="Receipt_TotalDownPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_TotalVAT" msprop:Generator_UserColumnName="Receipt_TotalVAT" msprop:Generator_ColumnPropNameInRow="Receipt_TotalVAT" msprop:Generator_ColumnVarNameInTable="columnReceipt_TotalVAT" msprop:Generator_ColumnPropNameInTable="Receipt_TotalVATColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_Total" msprop:Generator_UserColumnName="Receipt_Total" msprop:Generator_ColumnPropNameInRow="Receipt_Total" msprop:Generator_ColumnVarNameInTable="columnReceipt_Total" msprop:Generator_ColumnPropNameInTable="Receipt_TotalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_Remaining" msprop:Generator_UserColumnName="Receipt_Remaining" msprop:Generator_ColumnPropNameInRow="Receipt_Remaining" msprop:Generator_ColumnVarNameInTable="columnReceipt_Remaining" msprop:Generator_ColumnPropNameInTable="Receipt_RemainingColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_Pay" msprop:Generator_UserColumnName="Receipt_Pay" msprop:Generator_ColumnPropNameInRow="Receipt_Pay" msprop:Generator_ColumnVarNameInTable="columnReceipt_Pay" msprop:Generator_ColumnPropNameInTable="Receipt_PayColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Receipt_CreateDate" msprop:Generator_UserColumnName="Receipt_CreateDate" msprop:Generator_ColumnPropNameInRow="Receipt_CreateDate" msprop:Generator_ColumnVarNameInTable="columnReceipt_CreateDate" msprop:Generator_ColumnPropNameInTable="Receipt_CreateDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Receipt_UsersID" msprop:Generator_UserColumnName="Receipt_UsersID" msprop:Generator_ColumnPropNameInRow="Receipt_UsersID" msprop:Generator_ColumnVarNameInTable="columnReceipt_UsersID" msprop:Generator_ColumnPropNameInTable="Receipt_UsersIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReceiptDetails" msprop:Generator_UserTableName="ReceiptDetails" msprop:Generator_RowDeletedName="ReceiptDetailsRowDeleted" msprop:Generator_TableClassName="ReceiptDetailsDataTable" msprop:Generator_RowChangedName="ReceiptDetailsRowChanged" msprop:Generator_RowClassName="ReceiptDetailsRow" msprop:Generator_RowChangingName="ReceiptDetailsRowChanging" msprop:Generator_RowEvArgName="ReceiptDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="ReceiptDetailsRowChangeEventHandler" msprop:Generator_TablePropName="ReceiptDetails" msprop:Generator_TableVarName="tableReceiptDetails" msprop:Generator_RowDeletingName="ReceiptDetailsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReceiptDetails_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ReceiptDetails_ID" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_ID" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_ID" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_IDColumn" type="xs:int" />
              <xs:element name="ReceiptDetails_ReceiptID" msprop:Generator_UserColumnName="ReceiptDetails_ReceiptID" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_ReceiptID" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_ReceiptID" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_ReceiptIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ReceiptDetails_ItemID" msprop:Generator_UserColumnName="ReceiptDetails_ItemID" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_ItemID" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_ItemID" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_ItemIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ReceiptDetails_Quantity" msprop:Generator_UserColumnName="ReceiptDetails_Quantity" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_Quantity" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_Quantity" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_QuantityColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ReceiptDetails_Price" msprop:Generator_UserColumnName="ReceiptDetails_Price" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_Price" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_Price" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_PriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptDetails_DownPrice" msprop:Generator_UserColumnName="ReceiptDetails_DownPrice" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_DownPrice" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_DownPrice" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_DownPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptDetails_VAT" msprop:Generator_UserColumnName="ReceiptDetails_VAT" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_VAT" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_VAT" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_VATColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptDetails_Total" msprop:Generator_UserColumnName="ReceiptDetails_Total" msprop:Generator_ColumnPropNameInRow="ReceiptDetails_Total" msprop:Generator_ColumnVarNameInTable="columnReceiptDetails_Total" msprop:Generator_ColumnPropNameInTable="ReceiptDetails_TotalColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Unit" msprop:Generator_UserTableName="Unit" msprop:Generator_RowDeletedName="UnitRowDeleted" msprop:Generator_TableClassName="UnitDataTable" msprop:Generator_RowChangedName="UnitRowChanged" msprop:Generator_RowClassName="UnitRow" msprop:Generator_RowChangingName="UnitRowChanging" msprop:Generator_RowEvArgName="UnitRowChangeEvent" msprop:Generator_RowEvHandlerName="UnitRowChangeEventHandler" msprop:Generator_TablePropName="Unit" msprop:Generator_TableVarName="tableUnit" msprop:Generator_RowDeletingName="UnitRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Unit_ID" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Unit_ID" msprop:Generator_ColumnPropNameInRow="Unit_ID" msprop:Generator_ColumnVarNameInTable="columnUnit_ID" msprop:Generator_ColumnPropNameInTable="Unit_IDColumn" type="xs:int" />
              <xs:element name="Unit_Name" msprop:Generator_UserColumnName="Unit_Name" msprop:Generator_ColumnPropNameInRow="Unit_Name" msprop:Generator_ColumnVarNameInTable="columnUnit_Name" msprop:Generator_ColumnPropNameInTable="Unit_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Company" />
      <xs:field xpath="mstns:Company_ID" />
    </xs:unique>
    <xs:unique name="Customer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer" />
      <xs:field xpath="mstns:Customer_ID" />
    </xs:unique>
    <xs:unique name="CustomerType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CustomerType" />
      <xs:field xpath="mstns:CustomerType_ID" />
    </xs:unique>
    <xs:unique name="Income_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Income" />
      <xs:field xpath="mstns:Income_ID" />
    </xs:unique>
    <xs:unique name="IncomeDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IncomeDetails" />
      <xs:field xpath="mstns:IncomeDetails_ID" />
    </xs:unique>
    <xs:unique name="Item_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Item" />
      <xs:field xpath="mstns:Item_ID" />
    </xs:unique>
    <xs:unique name="Origin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Origin" />
      <xs:field xpath="mstns:Origin_ID" />
    </xs:unique>
    <xs:unique name="Provider_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Provider" />
      <xs:field xpath="mstns:Provider_ID" />
    </xs:unique>
    <xs:unique name="Receipt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Receipt" />
      <xs:field xpath="mstns:Receipt_ID" />
    </xs:unique>
    <xs:unique name="ReceiptDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReceiptDetails" />
      <xs:field xpath="mstns:ReceiptDetails_ID" />
    </xs:unique>
    <xs:unique name="Unit_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Unit" />
      <xs:field xpath="mstns:Unit_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>